USE [wdms]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetDocumentsSharedTo (
	@par_userid int)
AS
BEGIN
	SELECT [Document].[doc_title], [Doc_Share].[doc_id], [Doc_Share].[sh_read], [Doc_Share].[sh_update], [Doc_Share].[sh_check] 
	FROM [Doc_Share], [Document]
	WHERE @par_userid=[Doc_Share].[user_target_id]
END

